package com.loveazure.util;

public class SqlConstant {
	public static final String SELECT_LEARNED_WORD_SQL = "select word_learned_tbl.id,name,definition,psymbol,times,quality "
			+ "from word_dic_tbl,word_learned_tbl "
			+ "where word_learned_tbl.word_id=word_dic_tbl.id and user_id=$userid";

	public static final String GET_ALL_USERS_SQL = "select id,name from user_tbl";

	public static final String REFRESH_WORD_TIMES = "update word_learned_tbl set times=0 "
			+ "where (select count(*) from user_tbl where last_login==current_date and id=$user_id)=0 and id=$user_id";
}
